A.C.E. 2

home *** CD-ROM | disk | FTP | other *** search

/ A.C.E. 2 / ACE CD 2.iso / FILES / UTILS / PROCAL12.DMS / in.adf / Financial / Sources of Funds.PCF (.txt) < prev

Wrap

Gold Disk Spreadsheet | 1991-12-11 | 6.9 KB | 142 lines

Polar Bear Shirts Inc Sources of Funds Source Current Assets Cash 12000 30000 Accounts Receivable 35000 36000 Inventory 91000 86000 Raw Material 15000 17000 Work-In-Progress Finished Goods 40000 50000 Finished Goods Total Current Assets 201000 225000 Total Current Assets Fixed Assets Land Plant 355500 358500 Equipment 250000 240000 Equipment Total Fixed Assets 605500 598500 otal Fixed Assets Total Assets: 806500 823500 Current Liabilities Accounts Payable 17000 19000 Salaries Payable Taxes Payable Short-term Loans Total Liabilites 25000 28000 Long Term Debt Term Loans 100000 100000 Bond Issues SBA Loans 115000 112000 Total Long-term Debt 215000 212000 Net Worth Preferred Stock Common Stock 300000 300000 Retained Earnings 266500 283500 Total Net Worth 566500 583500 Liabilites + Equity 806500 823500 Revenues 250000 200000 Cost of Goods Sold 120000 100000 Gross Profit 130000 100000 ---------- Rent Depreciation 12000 14000 14000 Utilities General Expenses 10000 19000 Advertising 18000 10000 ---------- Total Costs 56000 61000 Operating Profit 74000 39000 ---------- Interest Expense 15000 18000 Taxable Profit 59000 21000 ---------- Income Tax 14000 After Tax Profit 45000 17000 17000 Dividends ---------- Retained Earnings 45000 17000 -------------------- Sources of Funds From Operations After Tax Profit 17000 Depreciation 14000 Total From Operations 31000 Decrease in Assets Total Sources 34000 Uses of Funds Increase in Assets 34000 Total Uses 34000